Store (In Database)
(In-Database Processing)
Synopsis
Stores the input data in the database.Description
This operator writes the input data into the database. Note that this operator requires proper CREATE TABLE privileges in the selected schema. No data is retrieved to the memory of the machine running this process unless the output of this operator is connected to a Nest output. This way, you can implement ETL processes without worrying about running out of memory, since the entire process will be pushed into the database.
Input
example set input
Output
- example set output
Parameters
- schema_name Name of the schema. Range: string
- table_name Output table. Range: string
- overwrite If it's enabled, the operator will drop the table and recreate it using the input data. If it's disabled, and the specified table already exists, then the execution will fail. WARNING: enabling this parameter may result in data loss. Range: boolean
